package com.ourteam.system.dao;

import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;

import org.apache.commons.lang.StringUtils;

import java.util.Arrays;
import java.util.List;
import java.util.Map;


/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2018-07-31 15:13:25
  * Warning ! This file will be overwrite when regenerate !
  *
 */
public class SysMessageResourceDAOQueryBean extends BaseQueryBean {
    public SysMessageResourceDAOQueryBean() {
        super();
    }

    public SysMessageResourceDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }

    public SysMessageResourceDAOQueryBean(BaseQueryBean aQueryBean,
        Map tableReplaceMap) {
        super(aQueryBean, tableReplaceMap);
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();

        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        return new Criteria(this);
    }

    public void addIdSelectProperty() {
        addIdSelectProperty("id");
    }

    public void addIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageResourceDAO.Id, aAlias);
        } else {
            addSelectProperty(ISysMessageResourceDAO.Id, "id");
        }
    }

    public void addLocalCodeSelectProperty() {
        addLocalCodeSelectProperty("localCode");
    }

    public void addLocalCodeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageResourceDAO.LocalCode, aAlias);
        } else {
            addSelectProperty(ISysMessageResourceDAO.LocalCode, "localCode");
        }
    }

    public void addMessageKeyIdSelectProperty() {
        addMessageKeyIdSelectProperty("messageKeyId");
    }

    public void addMessageKeyIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageResourceDAO.MessageKeyId, aAlias);
        } else {
            addSelectProperty(ISysMessageResourceDAO.MessageKeyId,
                "messageKeyId");
        }
    }

    public void addMessageValueSelectProperty() {
        addMessageValueSelectProperty("messageValue");
    }

    public void addMessageValueSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageResourceDAO.MessageValue, aAlias);
        } else {
            addSelectProperty(ISysMessageResourceDAO.MessageValue,
                "messageValue");
        }
    }

    public void addRemarksSelectProperty() {
        addRemarksSelectProperty("remarks");
    }

    public void addRemarksSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageResourceDAO.Remarks, aAlias);
        } else {
            addSelectProperty(ISysMessageResourceDAO.Remarks, "remarks");
        }
    }

    public void addStatusSelectProperty() {
        addStatusSelectProperty("status");
    }

    public void addStatusSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageResourceDAO.Status, aAlias);
        } else {
            addSelectProperty(ISysMessageResourceDAO.Status, "status");
        }
    }

    public void addMessageKeySelectProperty() {
        addMessageKeySelectProperty("messageKey");
    }

    public void addMessageKeySelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageResourceDAO.MessageKey, aAlias);
        } else {
            addSelectProperty(ISysMessageResourceDAO.MessageKey, "messageKey");
        }
    }

    public void addMessageCatalogSelectProperty() {
        addMessageCatalogSelectProperty("messageCatalog");
    }

    public void addMessageCatalogSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageResourceDAO.MessageCatalog, aAlias);
        } else {
            addSelectProperty(ISysMessageResourceDAO.MessageCatalog,
                "messageCatalog");
        }
    }

    public void addAllSelectProperties() {
        addIdSelectProperty();

        addLocalCodeSelectProperty();

        addMessageKeyIdSelectProperty();

        addMessageValueSelectProperty();

        addRemarksSelectProperty();

        addStatusSelectProperty();

        addMessageKeySelectProperty();

        addMessageCatalogSelectProperty();
    }

    public static class Criteria extends BaseWhereCriterion<SysMessageResourceDAOQueryBean> {
        protected Criteria(SysMessageResourceDAOQueryBean aParentObject) {
            super(aParentObject);
        }

        public Criteria andIdIsNull() {
            addCriterion(ISysMessageResourceDAO.Id + " is null");

            return this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion(ISysMessageResourceDAO.Id + " is not null");

            return this;
        }

        public Criteria andIdIsNotEmpty() {
            addCriterion(ISysMessageResourceDAO.Id + " is not null AND " +
                ISysMessageResourceDAO.Id + " <> ''");

            return this;
        }

        public Criteria andIdIsEmpty() {
            addCriterion("(" + ISysMessageResourceDAO.Id + " is null OR " +
                ISysMessageResourceDAO.Id + " = '')");

            return this;
        }

        public Criteria andIdEqualTo(long value) {
            return andIdEqualTo(Long.valueOf(value));
        }

        public Criteria andIdEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.Id + " = ", value, "id");

            return this;
        }

        public Criteria andIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Id);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Id + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotEqualTo(long value) {
            return andIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToOrIsNull(long value) {
            return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.Id + " is null OR " +
                ISysMessageResourceDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Id);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Id + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThan(long value) {
            return andIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.Id + " >", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Id);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Id + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(long value) {
            return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.Id + " >=", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Id);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Id + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThan(long value) {
            return andIdLessThan(Long.valueOf(value));
        }

        public Criteria andIdLessThan(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.Id + " <", value, "id");

            return this;
        }

        public Criteria andIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Id);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Id + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(long value) {
            return andIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.Id + " <=", value, "id");

            return this;
        }

        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Id);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Id + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdIn(long[] values) {
            if (values.length == 1) {
                return andIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.Id + " not in", values, "id");

                return this;
            }
        }

        public Criteria andIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.Id + " not in", values, "id");

                return this;
            }
        }

        public Criteria andIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.Id + " in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.Id + " not in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Id + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Id + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andIdBetween(long value1, long value2) {
            addCriterion(ISysMessageResourceDAO.Id + " between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageResourceDAO.Id + " between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(long value1, long value2) {
            addCriterion(ISysMessageResourceDAO.Id + " not between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageResourceDAO.Id + " not between", value1,
                value2, "id");

            return this;
        }

        public Criteria andLocalCodeIsNull() {
            addCriterion(ISysMessageResourceDAO.LocalCode + " is null");

            return this;
        }

        public Criteria andLocalCodeIsNotNull() {
            addCriterion(ISysMessageResourceDAO.LocalCode + " is not null");

            return this;
        }

        public Criteria andLocalCodeIsNotEmpty() {
            addCriterion(ISysMessageResourceDAO.LocalCode +
                " is not null AND " + ISysMessageResourceDAO.LocalCode +
                " <> ''");

            return this;
        }

        public Criteria andLocalCodeIsEmpty() {
            addCriterion("(" + ISysMessageResourceDAO.LocalCode +
                " is null OR " + ISysMessageResourceDAO.LocalCode + " = '')");

            return this;
        }

        public Criteria andLocalCodeEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " = ", value,
                "localCode");

            return this;
        }

        public Criteria andLocalCodeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.LocalCode);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andLocalCodeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andLocalCodeNotEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " <>", value,
                "localCode");

            return this;
        }

        public Criteria andLocalCodeNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " is null OR " +
                ISysMessageResourceDAO.LocalCode + " <>", value, "localCode");

            return this;
        }

        public Criteria andLocalCodeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.LocalCode);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andLocalCodeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andLocalCodeGreaterThan(String value) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " >", value,
                "localCode");

            return this;
        }

        public Criteria andLocalCodeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.LocalCode);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andLocalCodeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andLocalCodeGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " >=", value,
                "localCode");

            return this;
        }

        public Criteria andLocalCodeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.LocalCode);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andLocalCodeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andLocalCodeLessThan(String value) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " <", value,
                "localCode");

            return this;
        }

        public Criteria andLocalCodeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.LocalCode);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andLocalCodeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andLocalCodeLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " <=", value,
                "localCode");

            return this;
        }

        public Criteria andLocalCodeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.LocalCode);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andLocalCodeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andLocalCodeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.LocalCode + " like",
                buffer.toString(), "localCode");

            return this;
        }

        public Criteria andLocalCodeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.LocalCode + " not like",
                buffer.toString(), "localCode");

            return this;
        }

        public Criteria andLocalCodeIn(List<String> values) {
            if (values.size() == 1) {
                return andLocalCodeEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.LocalCode + " in", values,
                    "localCode");

                return this;
            }
        }

        public Criteria andLocalCodeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andLocalCodeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.LocalCode + " not in",
                    values, "localCode");

                return this;
            }
        }

        public Criteria andLocalCodeIn(String[] values) {
            if (values.length == 1) {
                return andLocalCodeEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.LocalCode + " in",
                    Arrays.asList(values), "localCode");

                return this;
            }
        }

        public Criteria andLocalCodeNotIn(String[] values) {
            if (values.length == 1) {
                return andLocalCodeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.LocalCode + " not in",
                    Arrays.asList(values), "localCode");

                return this;
            }
        }

        public Criteria andLocalCodeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andLocalCodeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andLocalCodeBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " between", value1,
                value2, "localCode");

            return this;
        }

        public Criteria andLocalCodeNotBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.LocalCode + " not between",
                value1, value2, "localCode");

            return this;
        }

        public Criteria andMessageKeyIdIsNull() {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " is null");

            return this;
        }

        public Criteria andMessageKeyIdIsNotNull() {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " is not null");

            return this;
        }

        public Criteria andMessageKeyIdIsNotEmpty() {
            addCriterion(ISysMessageResourceDAO.MessageKeyId +
                " is not null AND " + ISysMessageResourceDAO.MessageKeyId +
                " <> ''");

            return this;
        }

        public Criteria andMessageKeyIdIsEmpty() {
            addCriterion("(" + ISysMessageResourceDAO.MessageKeyId +
                " is null OR " + ISysMessageResourceDAO.MessageKeyId +
                " = '')");

            return this;
        }

        public Criteria andMessageKeyIdEqualTo(long value) {
            return andMessageKeyIdEqualTo(Long.valueOf(value));
        }

        public Criteria andMessageKeyIdEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " = ", value,
                "messageKeyId");

            return this;
        }

        public Criteria andMessageKeyIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKeyId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyIdNotEqualTo(long value) {
            return andMessageKeyIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andMessageKeyIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " <>", value,
                "messageKeyId");

            return this;
        }

        public Criteria andMessageKeyIdNotEqualToOrIsNull(long value) {
            return andMessageKeyIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andMessageKeyIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " is null OR " +
                ISysMessageResourceDAO.MessageKeyId + " <>", value,
                "messageKeyId");

            return this;
        }

        public Criteria andMessageKeyIdNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKeyId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyIdGreaterThan(long value) {
            return andMessageKeyIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andMessageKeyIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " >", value,
                "messageKeyId");

            return this;
        }

        public Criteria andMessageKeyIdGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKeyId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyIdGreaterThanOrEqualTo(long value) {
            return andMessageKeyIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andMessageKeyIdGreaterThanOrEqualTo(
            java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " >=", value,
                "messageKeyId");

            return this;
        }

        public Criteria andMessageKeyIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKeyId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyIdLessThan(long value) {
            return andMessageKeyIdLessThan(Long.valueOf(value));
        }

        public Criteria andMessageKeyIdLessThan(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " <", value,
                "messageKeyId");

            return this;
        }

        public Criteria andMessageKeyIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKeyId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyIdLessThanOrEqualTo(long value) {
            return andMessageKeyIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andMessageKeyIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " <=", value,
                "messageKeyId");

            return this;
        }

        public Criteria andMessageKeyIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKeyId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyIdIn(long[] values) {
            if (values.length == 1) {
                return andMessageKeyIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.MessageKeyId + " in",
                    values, "messageKeyId");

                return this;
            }
        }

        public Criteria andMessageKeyIdNotIn(long[] values) {
            if (values.length == 1) {
                return andMessageKeyIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.MessageKeyId + " not in",
                    values, "messageKeyId");

                return this;
            }
        }

        public Criteria andMessageKeyIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andMessageKeyIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.MessageKeyId + " in",
                    values, "messageKeyId");

                return this;
            }
        }

        public Criteria andMessageKeyIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andMessageKeyIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.MessageKeyId + " not in",
                    values, "messageKeyId");

                return this;
            }
        }

        public Criteria andMessageKeyIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andMessageKeyIdEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.MessageKeyId + " in",
                    Arrays.asList(values), "messageKeyId");

                return this;
            }
        }

        public Criteria andMessageKeyIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andMessageKeyIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.MessageKeyId + " not in",
                    Arrays.asList(values), "messageKeyId");

                return this;
            }
        }

        public Criteria andMessageKeyIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyIdBetween(long value1, long value2) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " between",
                value1, value2, "messageKeyId");

            return this;
        }

        public Criteria andMessageKeyIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " between",
                value1, value2, "messageKeyId");

            return this;
        }

        public Criteria andMessageKeyIdNotBetween(long value1, long value2) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " not between",
                value1, value2, "messageKeyId");

            return this;
        }

        public Criteria andMessageKeyIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageResourceDAO.MessageKeyId + " not between",
                value1, value2, "messageKeyId");

            return this;
        }

        public Criteria andMessageValueIsNull() {
            addCriterion(ISysMessageResourceDAO.MessageValue + " is null");

            return this;
        }

        public Criteria andMessageValueIsNotNull() {
            addCriterion(ISysMessageResourceDAO.MessageValue + " is not null");

            return this;
        }

        public Criteria andMessageValueIsNotEmpty() {
            addCriterion(ISysMessageResourceDAO.MessageValue +
                " is not null AND " + ISysMessageResourceDAO.MessageValue +
                " <> ''");

            return this;
        }

        public Criteria andMessageValueIsEmpty() {
            addCriterion("(" + ISysMessageResourceDAO.MessageValue +
                " is null OR " + ISysMessageResourceDAO.MessageValue +
                " = '')");

            return this;
        }

        public Criteria andMessageValueEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " = ", value,
                "messageValue");

            return this;
        }

        public Criteria andMessageValueEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageValue);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageValueEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageValueNotEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " <>", value,
                "messageValue");

            return this;
        }

        public Criteria andMessageValueNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " is null OR " +
                ISysMessageResourceDAO.MessageValue + " <>", value,
                "messageValue");

            return this;
        }

        public Criteria andMessageValueNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageValue);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageValueNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageValueGreaterThan(String value) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " >", value,
                "messageValue");

            return this;
        }

        public Criteria andMessageValueGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageValue);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageValueGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageValueGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " >=", value,
                "messageValue");

            return this;
        }

        public Criteria andMessageValueGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageValue);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageValueGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageValueLessThan(String value) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " <", value,
                "messageValue");

            return this;
        }

        public Criteria andMessageValueLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageValue);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageValueLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageValueLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " <=", value,
                "messageValue");

            return this;
        }

        public Criteria andMessageValueLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageValue);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageValueLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageValueLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.MessageValue + " like",
                buffer.toString(), "messageValue");

            return this;
        }

        public Criteria andMessageValueNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.MessageValue + " not like",
                buffer.toString(), "messageValue");

            return this;
        }

        public Criteria andMessageValueIn(List<String> values) {
            if (values.size() == 1) {
                return andMessageValueEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.MessageValue + " in",
                    values, "messageValue");

                return this;
            }
        }

        public Criteria andMessageValueNotIn(List<String> values) {
            if (values.size() == 1) {
                return andMessageValueNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.MessageValue + " not in",
                    values, "messageValue");

                return this;
            }
        }

        public Criteria andMessageValueIn(String[] values) {
            if (values.length == 1) {
                return andMessageValueEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.MessageValue + " in",
                    Arrays.asList(values), "messageValue");

                return this;
            }
        }

        public Criteria andMessageValueNotIn(String[] values) {
            if (values.length == 1) {
                return andMessageValueNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.MessageValue + " not in",
                    Arrays.asList(values), "messageValue");

                return this;
            }
        }

        public Criteria andMessageValueIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageValueNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageValueBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " between",
                value1, value2, "messageValue");

            return this;
        }

        public Criteria andMessageValueNotBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.MessageValue + " not between",
                value1, value2, "messageValue");

            return this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion(ISysMessageResourceDAO.Remarks + " is null");

            return this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion(ISysMessageResourceDAO.Remarks + " is not null");

            return this;
        }

        public Criteria andRemarksIsNotEmpty() {
            addCriterion(ISysMessageResourceDAO.Remarks + " is not null AND " +
                ISysMessageResourceDAO.Remarks + " <> ''");

            return this;
        }

        public Criteria andRemarksIsEmpty() {
            addCriterion("(" + ISysMessageResourceDAO.Remarks + " is null OR " +
                ISysMessageResourceDAO.Remarks + " = '')");

            return this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.Remarks + " = ", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Remarks);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Remarks + " = ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.Remarks + " <>", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageResourceDAO.Remarks + " is null OR " +
                ISysMessageResourceDAO.Remarks + " <>", value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Remarks);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Remarks + " <> ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion(ISysMessageResourceDAO.Remarks + " >", value, "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Remarks);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Remarks + " > ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.Remarks + " >=", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Remarks);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Remarks + " >= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion(ISysMessageResourceDAO.Remarks + " <", value, "remarks");

            return this;
        }

        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Remarks);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Remarks + " < ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.Remarks + " <=", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Remarks);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Remarks + " <= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.Remarks + " like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.Remarks + " not like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.Remarks + " in", values,
                    "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.Remarks + " not in",
                    values, "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(String[] values) {
            if (values.length == 1) {
                return andRemarksEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.Remarks + " in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(String[] values) {
            if (values.length == 1) {
                return andRemarksNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.Remarks + " not in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Remarks + " in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Remarks + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.Remarks + " between", value1,
                value2, "remarks");

            return this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.Remarks + " not between",
                value1, value2, "remarks");

            return this;
        }

        public Criteria andStatusIsNull() {
            addCriterion(ISysMessageResourceDAO.Status + " is null");

            return this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion(ISysMessageResourceDAO.Status + " is not null");

            return this;
        }

        public Criteria andStatusIsNotEmpty() {
            addCriterion(ISysMessageResourceDAO.Status + " is not null AND " +
                ISysMessageResourceDAO.Status + " <> ''");

            return this;
        }

        public Criteria andStatusIsEmpty() {
            addCriterion("(" + ISysMessageResourceDAO.Status + " is null OR " +
                ISysMessageResourceDAO.Status + " = '')");

            return this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.Status + " = ", value, "status");

            return this;
        }

        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Status);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Status + " = ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageResourceDAO.Status + " is null OR " +
                ISysMessageResourceDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Status);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Status + " <> ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion(ISysMessageResourceDAO.Status + " >", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Status);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Status + " > ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.Status + " >=", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Status);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Status + " >= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion(ISysMessageResourceDAO.Status + " <", value, "status");

            return this;
        }

        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Status);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Status + " < ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.Status + " <=", value, "status");

            return this;
        }

        public Criteria andStatusLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.Status);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Status + " <= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.Status + " like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.Status + " not like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.Status + " in", values,
                    "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.Status + " not in", values,
                    "status");

                return this;
            }
        }

        public Criteria andStatusIn(String[] values) {
            if (values.length == 1) {
                return andStatusEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.Status + " in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(String[] values) {
            if (values.length == 1) {
                return andStatusNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.Status + " not in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Status + " in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.Status + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.Status + " between", value1,
                value2, "status");

            return this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.Status + " not between",
                value1, value2, "status");

            return this;
        }

        public Criteria andMessageKeyIsNull() {
            addCriterion(ISysMessageResourceDAO.MessageKey + " is null");

            return this;
        }

        public Criteria andMessageKeyIsNotNull() {
            addCriterion(ISysMessageResourceDAO.MessageKey + " is not null");

            return this;
        }

        public Criteria andMessageKeyIsNotEmpty() {
            addCriterion(ISysMessageResourceDAO.MessageKey +
                " is not null AND " + ISysMessageResourceDAO.MessageKey +
                " <> ''");

            return this;
        }

        public Criteria andMessageKeyIsEmpty() {
            addCriterion("(" + ISysMessageResourceDAO.MessageKey +
                " is null OR " + ISysMessageResourceDAO.MessageKey + " = '')");

            return this;
        }

        public Criteria andMessageKeyEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " = ", value,
                "messageKey");

            return this;
        }

        public Criteria andMessageKeyEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKey);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyNotEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " <>", value,
                "messageKey");

            return this;
        }

        public Criteria andMessageKeyNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " is null OR " +
                ISysMessageResourceDAO.MessageKey + " <>", value, "messageKey");

            return this;
        }

        public Criteria andMessageKeyNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKey);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyGreaterThan(String value) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " >", value,
                "messageKey");

            return this;
        }

        public Criteria andMessageKeyGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKey);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " >=", value,
                "messageKey");

            return this;
        }

        public Criteria andMessageKeyGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKey);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyLessThan(String value) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " <", value,
                "messageKey");

            return this;
        }

        public Criteria andMessageKeyLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKey);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " <=", value,
                "messageKey");

            return this;
        }

        public Criteria andMessageKeyLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageKey);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageKeyLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.MessageKey + " like",
                buffer.toString(), "messageKey");

            return this;
        }

        public Criteria andMessageKeyNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.MessageKey + " not like",
                buffer.toString(), "messageKey");

            return this;
        }

        public Criteria andMessageKeyIn(List<String> values) {
            if (values.size() == 1) {
                return andMessageKeyEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.MessageKey + " in", values,
                    "messageKey");

                return this;
            }
        }

        public Criteria andMessageKeyNotIn(List<String> values) {
            if (values.size() == 1) {
                return andMessageKeyNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.MessageKey + " not in",
                    values, "messageKey");

                return this;
            }
        }

        public Criteria andMessageKeyIn(String[] values) {
            if (values.length == 1) {
                return andMessageKeyEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.MessageKey + " in",
                    Arrays.asList(values), "messageKey");

                return this;
            }
        }

        public Criteria andMessageKeyNotIn(String[] values) {
            if (values.length == 1) {
                return andMessageKeyNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.MessageKey + " not in",
                    Arrays.asList(values), "messageKey");

                return this;
            }
        }

        public Criteria andMessageKeyIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageKeyBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " between",
                value1, value2, "messageKey");

            return this;
        }

        public Criteria andMessageKeyNotBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.MessageKey + " not between",
                value1, value2, "messageKey");

            return this;
        }

        public Criteria andMessageCatalogIsNull() {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " is null");

            return this;
        }

        public Criteria andMessageCatalogIsNotNull() {
            addCriterion(ISysMessageResourceDAO.MessageCatalog +
                " is not null");

            return this;
        }

        public Criteria andMessageCatalogIsNotEmpty() {
            addCriterion(ISysMessageResourceDAO.MessageCatalog +
                " is not null AND " + ISysMessageResourceDAO.MessageCatalog +
                " <> ''");

            return this;
        }

        public Criteria andMessageCatalogIsEmpty() {
            addCriterion("(" + ISysMessageResourceDAO.MessageCatalog +
                " is null OR " + ISysMessageResourceDAO.MessageCatalog +
                " = '')");

            return this;
        }

        public Criteria andMessageCatalogEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " = ", value,
                "messageCatalog");

            return this;
        }

        public Criteria andMessageCatalogEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageCatalog);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageCatalogEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageCatalogNotEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " <>", value,
                "messageCatalog");

            return this;
        }

        public Criteria andMessageCatalogNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog +
                " is null OR " + ISysMessageResourceDAO.MessageCatalog + " <>",
                value, "messageCatalog");

            return this;
        }

        public Criteria andMessageCatalogNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageCatalog);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageCatalogNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageCatalogGreaterThan(String value) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " >", value,
                "messageCatalog");

            return this;
        }

        public Criteria andMessageCatalogGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageCatalog);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageCatalogGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageCatalogGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " >=", value,
                "messageCatalog");

            return this;
        }

        public Criteria andMessageCatalogGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageCatalog);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageCatalogGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageCatalogLessThan(String value) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " <", value,
                "messageCatalog");

            return this;
        }

        public Criteria andMessageCatalogLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageCatalog);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageCatalogLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageCatalogLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " <=", value,
                "messageCatalog");

            return this;
        }

        public Criteria andMessageCatalogLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageResourceDAO.MessageCatalog);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andMessageCatalogLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageCatalogLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " like",
                buffer.toString(), "messageCatalog");

            return this;
        }

        public Criteria andMessageCatalogNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " not like",
                buffer.toString(), "messageCatalog");

            return this;
        }

        public Criteria andMessageCatalogIn(List<String> values) {
            if (values.size() == 1) {
                return andMessageCatalogEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.MessageCatalog + " in",
                    values, "messageCatalog");

                return this;
            }
        }

        public Criteria andMessageCatalogNotIn(List<String> values) {
            if (values.size() == 1) {
                return andMessageCatalogNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageResourceDAO.MessageCatalog + " not in",
                    values, "messageCatalog");

                return this;
            }
        }

        public Criteria andMessageCatalogIn(String[] values) {
            if (values.length == 1) {
                return andMessageCatalogEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.MessageCatalog + " in",
                    Arrays.asList(values), "messageCatalog");

                return this;
            }
        }

        public Criteria andMessageCatalogNotIn(String[] values) {
            if (values.length == 1) {
                return andMessageCatalogNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageResourceDAO.MessageCatalog + " not in",
                    Arrays.asList(values), "messageCatalog");

                return this;
            }
        }

        public Criteria andMessageCatalogIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageCatalogNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andMessageCatalogBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog + " between",
                value1, value2, "messageCatalog");

            return this;
        }

        public Criteria andMessageCatalogNotBetween(String value1, String value2) {
            addCriterion(ISysMessageResourceDAO.MessageCatalog +
                " not between", value1, value2, "messageCatalog");

            return this;
        }
    }
}
